Power BI
About the Course:
POWER BI is a tool that facilitates Business Intelligence. In Today’s environment every Business perform huge amount of Customer Transactions and dealings which cannot be analysed manually in short period of time and thus every business depends on Technology for accurate data analysis, extraction and presentation to frame their future Strategy. Power Bi Fulfil this requirement of business by offering the tools for the process of Extraction of data, Analysis, Transformation and Visualization to make insightful Division.
Duration: 2 Days (8 Hours Per Day)
Course Objective:
- Data Extraction
- Data Transformation
- Data Loading
- Data Modelling
- Data Analysis Expressions
- Data Analysis
- Data Visualization
- Data Driven Decisions.
- Data Publishing
Learning Outcome:
- To Know about various Methods of Extracting data.
- Learn Various tools and Methods for data Cleaning and Data Transformation.
- Understand How to create relationship with different sources of data
- Learn how to create data Analysis Function for preparing Reports.
- Learn to Analysis various ways of Data Analysis
- Learn to prepare Dashboards and Different types of visuals for effective decision Making
- SCOPE
- Data Analyst
- Business Analyst
Course Outline
- Concept of Data Analysis
- Concept of Business Intelligence.
- Introduction to Power Bi
- Power Bi Architecture
- Power Bi Components
- Installing Power Bi Desktop.
- Extract/Connect Data
- Getting data from Flat Files
- Getting Data from open Data Feeds
- Getting Data from Folder
- Difference between Transform and Load Data
- Power query Editor
- Data Transformation
- Data Formatting and Extraction
- Formatting by Add Column
- Merge, Add & Remove Columns in Power Query
- Sorting in Power query
- Merge and Append query
- Transform Table Tools
- Text Column Tools
- Number Column Tools
- Power Query Editor Advanced Options
- Building a complete Calendar Table
- Conditional Custom & Invoke Custom
- Flash fill in Power Query (Columns from example)
- Understanding different view options
- Connect to multiple files in a folder
- Column Profiling in Power query Editor
- Data Modelling in Power Bi
- How to build relationship and relationship cardinality
- Understanding filter flow & Cross Filter direction
- Building entire model
- Snowflake & Star schema
- Add Related table
- Data Analysis Expressions
- Understanding DAX and its Types
- Difference between calculated columns and measures
- Logical DAX
- Another example of conditional column
- Understanding SWITCH function
- Understanding Year and Today function
- Playing with Text functions (Left and Search)
- Most Common used DAX Measures
- DAX Iterators
- Date & Time DAX
- Report Setup in Power Bi Desktop
- Understanding Report view and creating a new report
- Page display settings in a Power BI report
- Setting color theme aligned to project/company color theme & Theme Gallery
- Adding non-visualization object
- Inserting Basic charts and understanding format tab
- Creating Comparison visuals (Doughnut Chart)
- Creating Bar chart for Top 5 Customers
- Geographical Visualization
- Understanding Matrix visual along with Conditional Formatting
- Comparing Actual vs. Target using Gauge Chart
- Slicing and Dicing in Reports
- Advanced Visualization/Custom Visualization Options
- Showing monthly trend with line chart
- Setting up forecasted revenue in line chart
- Presenting data in an Area chart with awesome tooltip feature
- Building amazing KPI’s
- Drill through Report Page
- Custom visual (third party visual)
- Story telling through Bookmarks
- Ask questions from PBI and get visuals (NLQ)
- Module:9 Publishing Report & Advanced Report Options
- What if Parameter
- Setting RLS (Row Level Security)
- Tooltip Page
- Different types of filters in report view
- Change how visuals interact in a report
- Publishing Reports
- Importing Report to Power Point
- Power Bi Project for Pro Training Analaysis.