Details
What is Power BI?
Power BI is a suite of business analytics tools that deliver insights throughout your organization. Connect to hundreds of data sources, simplify data prep, and drive ad hoc analysis. Produce beautiful reports, then publish them for your organization to consume on the web and across mobile devices. Everyone can create personalized dashboards with a unique, 360-degree view of their business. And scale across the enterprise, with governance and security built-in.
Objectives
At the end of this course the student must be capable on the following skillsets
Power BI is a suite of business analytics tools that deliver insights throughout your organization. Connect to hundreds of data sources, simplify data prep, and drive ad hoc analysis. Produce beautiful reports, then publish them for your organization to consume on the web and across mobile devices. Everyone can create personalized dashboards with a unique, 360-degree view of their business. And scale across the enterprise, with governance and security built-in.
Objectives
At the end of this course the student must be capable on the following skillsets
- Connecting and Shaping data using Query Editor
- Creating a Data Model by connecting tables with BI relationship tools
- Creating DAX , Measures and Calculated Columns for Data Analytics
- Create Dynamic Dashboards using Power BI Visuals
Outline
Course Outline
Module 1: Meet Microsoft Power BI
Module 6: Introduction to Data Model
Course Work Exercise 2: Creating a Data Model
Module 9: Meet Data Analysis Expressions (DAX)
Course Work Exercise 3: Adding Calculated Fields
Module 12: Introduction to Reports and Dashboards
Course Work Exercise 4: Visualizing Data with Reports Create a Complete Project using Power BI Tools.
Module 1: Meet Microsoft Power BI
- Setting up Power BI Properties
- The Power BI Interface and Workflow
- Helpful Resources Module
- Types of Data Connectors
- The Query Editor Interface
- Basic Table Transformations
- Text-Specific Tools
- Number-Specific Tools
- Date-Specific Tools Creating a Rolling Calendar
- Index and Conditional Columns
- Grouping and Aggregating Data
- Pivoting and Unpivoting Data Module
- Merging Queries
- Appending Queries
- Appending Queries from a Folder Module
- Data Source Settings
- Query Refresh Settings
- Additional Types and Categories
- Defining Heirarchies
- Importing Models from Excel Power Tools
Module 6: Introduction to Data Model
- What is a Data Model?
- Database Normalization
- Data Tables vs Lookup Tables
- Relationship vs Merge Tables
- Snowflakes Schema
- Managing and Editing Relationships
- Active vs Inactive Relationships
- Relationship Cardinality
- Understanding Filter Flow
- Two Way Filter Flow
- Hiding Fields from Report View
Course Work Exercise 2: Creating a Data Model
Module 9: Meet Data Analysis Expressions (DAX)
- Introduction to Calculated Columns and Measures
- Adding Columns and Measures
- Implicit and Explicit Measures
- Filter Context Samples
- Step by Step Measure Calculation Module
- Common DAX Functions and Categories
- Basic Date and Time Functions
- Basic Logical Functions
- Text Functions Module
- Joining Data with Related
- Math and Stats Functions
- COUNT Functions
- CALCULATED Function
- CALCULATE and ALL Function
- CALCULATE and FILTER Function
- Iterator X Functions
- DAX Time Intelligence Formulas
Course Work Exercise 3: Adding Calculated Fields
Module 12: Introduction to Reports and Dashboards
- The Report View
- Adding Simple Objects
- Inserting Basic Charts and Visual
- Formatting Options
- Report Filtering Options Module 13: Different Visuals in Power BI
- DEMO: Matrix Visuals
- DEMO: Date Slicers
- DEMO: Cards and KPI’s
- DEMO: Text Cards
- DEMO: Map Visuals
- DEMO: Tree Maps
- DEMO: Line and Area Charts
- DEMO: Trend-lines and Forecast
- DEMO: Gauge Charts
- Editing Report Interactions
- Adding Drill-through Filter
- Adding Report Bookmark
- Adding What-if Parameter
- Managing and Viewing Role
- Preview: Custom Visual
- Preview: Publishing to Power BI Services
Course Work Exercise 4: Visualizing Data with Reports Create a Complete Project using Power BI Tools.
Reviews
Be the first to write a review about this course.
Write a Review
We are a technology and training solutions company aiming to help small and large organizations accomplish their learning & business goals by providing industry-relevant training, certifications, and technology solutions aligned with today's digital transformation
Our training and certification programs are designed to equip your team with the skills and knowledge they need to thrive in today's digital economy.
As digital transformation continues to shape the business landscape, it's essential for companies like yours to stay ahead of the curve.
Each of our live virtual programs below is led by experienced and world-class instructors who bring real-world expertise and hands-on experience to the classroom.
- Project Management(Project Management Fundamentals, PMP, Digital PM, Agile Courses, Prince 2 etc.)
- IT Service Management courses(ITIL4, TOGAF, Service Desk, COBIT 5, etc.)
- Cyber Security Expert Training(CompTIA Sec+, CISSP, CISM, CISA, Basic Cyber & IT Security etc.)
- Data Science & Business Analytics(Tableau, Power BI, MS Excel, Data Analyst, Data Science etc.)
- Six Sigma Certification training(Yellow-belt, Green-belt, Black-belt, Six Sigma Expert Master’s Program etc.) ...
NXT AIS INC.
3F Julio Antion Bldg III Maysilo Circle Mandaluyong City Philippines, Mandaluyong , Metro Manila, Philippines