TRAINING
Upcoming Workshop Chennai

Learn from The Experts
Tableau Training
Price: 12,000/Head Duration: 24 Hours (4 hours x 3 weekends) Date: Feb 1st , 2nd, 8th, 9th, 15th & 16thTiming: 9:30 AM To 1:30 PM
Tableau Course Outline
- Getting Started with Tableau
- Connecting to Data
- Understanding Data Fields
- Creating Simple Visualizations
- Formatting Visualizations
- Filtering and Sorting Data
- Advanced Visualizations
- Different Chart Types
- Calculated Fields
- Table Calculations
- Hierarchies & Groups
- Creating Bins & Histogram
- Working with Sets
- Working with Parameters
- Level of Detail Expressions (Lod)
- Reference Lines, Bands & Distributions
- Trends Lines and Forecasting
- Complex Visualizations
- Building Tableau Dashboard
- Interactive Dashboard Concepts
- Story Points
- Saving & Exporting
- Publishing Tableau Dashboard

Learn from The Experts
Power BI Training
Price: 12,000/Head Duration: 24 Hours (4 hours x 3 weekends) Date: Feb 1st , 2nd, 8th, 9th, 15th & 16thTiming: 2:00 AM To 6:00 PM
Power BI Course Outline
- Introduction to Power BI Desktop
- Query Editor Overview
- Importing Data from various sources
- Understanding Query Design & the ETL Process
- Data Transformations
- -- Cleaning data
- -- Merging Datasets
- -- Unpivoting Data
- -- Combining Files from a folder
- -- Appending datasets
- Using a Dynamic Fiscal Calendar Table
- Creating a Data Model
- Data Types & Formatting
- Extending the Data Model with Calculated Columns
- Creating Calculated Measures
- Understanding DAX syntax
- Implicit Vs Explicit Measures
- Commonly Used DAX Functions
- -- Sum, Average, Distinct Count
- -- Time Intelligence (MTD, QTD, YTD, Prior Year)
- -- SUMX, COUNTX and CALCULATE
- -- Filter, All
- -- IF, Switch, HasOneValue
- -- RELATED
- Using Quick Measures
- Charts in Power BI Desktop
- Text-Based Visualizations
- Analyzing Data Over Time
- Sort based on Values/ Fields
- Slicers and Filters
- Understanding KPI cards
- Using Field, Format, Analytics Pane
- Build a Monthly Trend Report
- Build a Tabular Report (Matrix)
- Types of Conditional Formatting
- Drill-Downs & Drill-Through
- Hierarchies
- Groups & Bins
- Slice by Relative Dates
- Focus Mode - See Details
- Setting Visual Interactivity
- Exporting Data from Power BI Desktop
- Using Power BI Desktop Quick Insights
- Handling Multiple relationships with the fact table
- Building Reports using Q&A
- Publishing to the cloud Service
- Security – Add Users to Defined Roles
- Sharing Dashboards & Reports
- Scheduling Data Refreshes
- Refreshing On-Demand
Register for Workshop
Location
Big D Academy
No.1, 12th Cross St, Mahalakshmi Nagar, Adambakkam, Chennai Contact: +91 8838 666 078Email: [email protected]
Why BigD Academy
- Industry Expert Trainers
- Interactive Class-room Sessions
- Hand-on Training
- Real-time Examples
- Post Training Support