Power BI / MS Power BI

ou will learn following topics with this Power BI training course online:

1. An in-depth understanding of this BI tool and how it works in different scenarios

2. Three vital components: Power BI Service, Desktop and Mobile Apps
3. Visualize and analyze data and derive insights from Excel spreadsheets or local databases
4. Create compelling reports and visualizations, derive real-time insights, and deploy them on demand
5. Create, share, collaborate, and benefit from business information with purpose-built dashboards
6. Get the work done without being a Business Intelligence professional
7. Use Salesforce Data, Azure SQL Database, and SQL Server analysis tabular data
8. Deploy content packs to work with QuickBooks online and Adobe Analytics
9. Work on live projects to get hands-on experience.

WISSEN SKILLS AND CONSULTING
TECHNOLOGY SKILLING PROGRAM
POWER-BI (W.I.PO)

Overview and Brief:

Wissen Skills and Consulting’s program on Power BI (W.I.Po) transforms your company data into rich visuals that facilitate new ways of thinking about and organizing your data, so that the focus is on what is important to achieving your goals.

Course Output:

Upon completing this course, one will have a basic understanding of the topics below, as well as an ability to utilize and implement the concepts learned.

• Power BI
• Power BI Desktop
• Working with CSV, TXT, and Excel Worksheets
• Connecting to Databases
• Merging, Grouping, Summarizing, and Calculating Data
• Reporting
• Power BI Online

Program and Module (Level-1):

TOPIC 1: GETTING STARTED WITH POWER BI DESKTOP

• Introduction to Self-Service BI
• Introduction Power BI Desktop
• Power BI Workflow
• Power BI Architecture
• Power BI Services
• Power BI Components
• Visualizations, Filters & Fields Pane

TOPIC 2: CONNECTING TO DATA SOURCES WITH POWER BI DESKTOP

• Data Sources Power BI Desktop will connect to
• On-Premises Data Files Databases
• Online Databases
• Software as a Service (SaaS) Providers
• Internet Data
• Data Types and Properties in Power BI Desktop
• Enter Data
• Get Data and Query Editor
• Introducing the Query Editor
• Using the Query Editor to Connect to Data
• Combining Data Sources as a Mash Up
• Use Append Queries
• Merge Data Tables
• Working with Relationships in Data

TOPIC 3: QUERYING AND SHAPING THE DATA

• Activities using Query Editor
• Filters
• Clean, Trim, Format and Replace
• Split Column or Extract Using Delimiters
• Column from Example
• UnPivot
• Creating Custom Calculated Columns
• Adding Conditional Columns
• Introduction to DAX Expressions and Formula

TOPIC 4: DATA VISUALIZATIONS

• Overview of Data Visualizations
• Tables and Matrix Views
• Charts
• Bar/Column Charts
• Clustered
• Stacked
• 100% Stacked
• Ribbon Charts
• Waterfall Charts
• Line Chart
• Scatter Chart
• Area Charts
• Line-and-Column Charts
• Pie Charts
• Donut charts
• Map Charts
• Funnel Chart
• Gauge Chart
• Card Chart
• Multi-Row Card
• Tree Maps
• Charts from Marketplace
• Aster Plot
• Bullet Plot
• Chord
• Histogram
• Stream Graph
• Tornado
• Sankey
• Chart Formatting
• Sort Visuals by Values/Fields
• Inserting Text Box, Shapes & Images
• Applying Conditional Formatting
• Color Scale
• Rules
• By Field Values
• Icon Set
• Interactive Slicers
• Date Slicers – dropdowns and searches
• Number Slicers with value ranges
• Date Slicers with Relative filters
• Drill Visualizations to see underlying data
• Create Reusable Field Hierarchies
• Record Grouping and Binning in Visualizations
• Analytics Lines in Visualizations
• Forecast
• DAX
• Calculated Columns
• FORMAT
• REALTED
• DATEVALUE
• Create Measures
• SUM, COUNT, MAX, MIN
• COUNTROWS, DIVIDE
• DISTINCT COUNT
• SUMX, COUNTX, AVERAGEX
• CALCUATE
• IF ELSE
• AND, OR, NOT
• Create a KPI Visualization
• Drill Visualizations to see underlying Data
• Visual Table and Data Point Table
• Date Hierarchies
• Q&A
• Decomposition Tree
• Data Categories, Geo-Data and Maps

TOPIC 5: REPORTS AND OUTPUT OPTIONS

• Report Elements and Options
• Working with Pages
• Visual and Filter Settings
• Edit Interactions
• Bookmarks
• Synchronize Slicer
• Report Themes
• Buttons and Q&A

TOPIC 6: PUBLISH & SHARING REPORTS

• Publish Report from Power Desktop
• Understanding Dashboards, Tiles, Reports, Datasets, workbooks
• Creating Dashboard
• Pinning Tiles to Dashboard
• Sharing Reports & Dashboards
• Publish Reports to Web
• Print or Save as PDF
• Exporting to PowerPoint
• Export Data from Visualization
• Refreshing Data Sets

Course Duration:- 40 hours

Plan of training:- 2 hours every day for 20 days ( Monday to Friday)