Data Analytics with Power BI Course (and projects)

Course Length: 8 to 10 Weeks

Audience: Students with or without IT experience or knowledge
Student Location: To students from around the world
Delivery Method: Instructor-Led – Live Training Classroom and/or Online

Register for Demo
Enroll Now

Data Analytics with Power BI and Projects

Get ready to level up your skills with our Data Analytics with Power BI course. With the help of our expert instructors, you’ll learn how to analyze and visualize data like never before. Gain hands-on experience with real-world projects and learn how to analyze, visualize and present data using Power BI. Take your career to new heights with this in-demand skillset.

Key Features

10 Weeks Instructor-Led Online Training
Certification & Job Assistance
Flexible Schedule
24 x 7 Lifetime Support
100% Job Oriented Training
Work on Real-time Projects

Course Syllabus


Introduction to Data Analysis

  • Intro to Data Analysis
  • Steps to prepare data for Data Analysis
  • Types of Data Analysis

Who is a Database Analyst?

  • What are the roles of Database Analyst?
  • Difference between Business Analyst and Database Analyst
  • OLTP v/s OLAP

Environment SQL Setup

  • What is SQL Server?
  • SQL Server Installation Requirements
  • Connect to SQL Server with SSMS
  • SQL Server Configuration Manager
  • Download and Install SSDT

Data Analysis with ETL with SSIS

  • ETL process
  • What is SSIS
  • Create a new SSIS project
  • Add flat file connection manager
  • Remap column data types
  • Configure OLE DB connection Manager
  • Add a data flow task
  • Add and Configure Flat file source
  • Add and Configure OLE DB Destination
  • Test and Run Package

Data Analytics with SQL and Table Joins

  • What is SQL?
  • SQL Syntax
  • What is TSQL?
  • SQL Server Data Types
  • SQL Server Functions (Count, Sum, Avg, Min, Max)
  • Operators
  • SQL Commands
    • DDL
    • DML
    • TCL
  • Sub Query
  • Joins
  • SQL homework 1, 2, and 3

Starting with Power BI

  • What is Power BI?
  • What is Power BI Desktop
  • Install Power BI Desktop
  • Exploring Power BI Desktop
  • Power BI Overview
  • Components of Power BI
  • Exploring Power BI Desktop Interface
  • Power BI Licensing

Data Loading with Power BI Desktop

  • Types of different Data loading modes
    • Import
    • Direct
    • Live
  • Excel, CSV, PDF, SharePoint, Folder
  • SQL Data loading
  • Cube Data loading
  • Combining Data Sources
  • Appropriate HomeWorks

Data Transformation with Power BI

  • Transforming Database Data
  • Changing Locale
  • Connecting to access database data
  • Power Query Editor and Queries
  • Creating and managing query groups
  •  Renaming Queries
  • Splitting Columns
  • Changing Data Types
  •  Removing and Reordering Columns
  • Duplicating and adding columns
  • Creating Conditional Columns
  • Connecting to files in folders
  • Appending Queries
  • Merge/Joins Queries
  • Query Dependency Views
  • Transforming Less Structured Data Creating Tables
  • Query Parameters
  • Appropriate HomeWorks

Data Modeling

  • Introduction to Data Models
  • Components of Data Modeling
  • Data Model Engine
  • Types of Data Model (Flat, Star & Snowflake)
  • Granularity of Data & multiple fact tables
  • Data Modeling Relationships
    • One to One
    • One to Many
    • Many to Many
  • Roll Playing Tables
  • Sorting/Renaming/Hiding Tables
  • Hierarchy Creation
  • Formatting & Data Category
  • Grouping / Binning
  • Drill Through Reports
  • What IF Parameter
  • Appropriate HomeWorks

DAX

  • Introduction DAX
  • DAX Data Types
  • Calculated Columns
  • Calculated Tables
  • Calculated Measures
  • Calculated Columns vs Measures
  • Aggregated Functions (SUM, MIN, MAX, AVG, COUNT)
  • Relate Functions (RELATED & RELATED TABLE)
  • Iterative Functions (SUMX, AVGX, COUNTX)
  • Variables (VAR)
  • Logical functions (AND, OR, IF, SWITCH)
  • Table Functions (VALUES, FILTER, CALCUILATETABLE)
  • FORMAT FUNCTION, FIND, SEARCH, SUBSTITUE, VALUE, UNION, ROW, ADDCOLUMNS, SUMMARIZE
  • Handling Blanks (ISBLANK, NOTISBLANK)
  • Rank Functions (RANKX)
  • CALCULATE (ALL, ALLEXCEPT, ALLSELECTED)
  • Understand Row & Table level Filter Context
  • Date Functions (DATEADD, DATEDIFF, TODAY Required Date Formats)
  • Calendar Functions (CALENDAR, CALENDAT AUTO)
  • Time Intelligence functions (TOTALMTD, TOTALQTD, TOTALYTD, PARALLELPERIOD, SAMEPERIODLASTYEAR, PARALLELPERIOD, RUNING TOTAL)
  • SEMI ADDITIVE (OPENING BALANCE, CLOSING BALANCE, LAST DATE, FIRST DATE, LASTNONBLANK, FIRSTNONBLANK)
  • Appropriate HomeWorks

Power BI Visualization

  • Designer Options
  • Power BI Visualization Types
  • Custom Visualization
  • Best Practices
  • Choosing Colors
  • Types of Charts and Usage
  • Slicers / Filters
  • Creating Complete Visualization Report (Practical)
  • Story Telling with the created Report
  • Bookmarks and Selection Pane
  • Spotlight
  • Drill Through
  • Additional Features
  • Appropriate HomeWorks

 

Power BI Service (Two Months Power BI Pro License)

  • Publishing / Deploying Reports
  • Apps Workspace & Roles
  • Creating Dashboard
  • Q&A
  • Quick Insights
  • Dashboard Options
  • Subscription
  • Alerts
  • Export Options (Embed, Web, Power Point…etc.)
  • Excel Integration
  • Row Level Security
    • Static
    • Dynamic
  • Data Refresh Concept
  • Gateway and Installation
  • Power BI Mobile Service
  • Power BI Admins Roles
  • Audit Logs
  • Appropriate HomeWorks

Project & Discussion (Q&A)

  • Project 1
  • Project 2

FAQ'S

Do I get any discount on the course?

Yes, you get two kinds of discounts. They are group discount and referral discount. Group discount is offered when you join as a group, and referral discount is offered when you are referred from someone who has already enrolled in our training.

Who will provide the environment to execute the Practicals ?

The trainer will give Server Access to the course seekers, and we make sure you acquire practical hands-on training by providing you with every utility that is needed for your understanding of the course.

What is the qualification of the trainer?

The trainer is a certified consultant and has significant amount of experience in working with the technology.

Does MyyesM accept the course fees in installments?

Yes, we accept payments in two installments.

How does MyyesM Refund Policy work?

If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within first 2 sessions of the training. Please make a note that refunds will be processed within 30 days of prior request.

Course Testimonials

I have no idea where to start. Because of Yes M Systems, I'm earning a decent amount of salary. The expertise in Data Science I acquired from them has made my life. Thank you to all the encouraging instructors.
Sharmistha
In the majority of online course-providing platforms, you are always left out on one topic or the other. With Yes-M Systems, you never experience the same. They cover every little aspect of the topic so elaborately and they make complex areas super easy.
Amrita
I guess I made the right choice by going with Yes M Systems Data Science Course with a special focus on Machine Learning, SQL and PowerBI. The course teaches basic as well as advanced topics clearly.
Manasvi R

Disclaimer: Yes-M Systems and/or their instructors reserve the right to make any changes to the syllabus as deemed necessary to best fulfill the course objectives. Students registered for this course will be made aware of any changes in a timely fashion using reasonable means.

Call for Enquiry