Business Analytics Masters with 3 month Internship

Learn the power of using powerful visualization tools such as PowerBi and Tableau alongside advanced excel coupled with the most important fundamentals of Python

Start Date: 27th February 2021
Class Timings: 10:00 AM to 12:00 PM (IST) Saturday - Sunday
Doubt Clearing Session: 3:30 PM IST to 5:30 PM IST (IST) Monday

Course Overview

This is a detailed Business analytics course where you will learn Python Core, PowerBi, Tableau, advanced Excel and statistics to give you the most competitive edge.

What you'll learn
  • Python
  • PowerBI
  • Tableau
  • Advanced Excel
  • Statistics
Requirements
  • Laptop
  • Stable internet connection

Course Curriculum

  • Install setup and overview
  • Ipython /Jupiter Notebook overview.
  • Intro to NUMPY.
  • Creating Arrays.
  • Using Arrays and Scalar.
  • Indexing Arrays.
  • Arrays transposition.
  • • Universal arrays function.
  • Arrays processing.
  • Array input and output.
  • Series.
  • Data frames.
  • Index Objects.
  • Re index.
  • Drop entry.
  • Selecting entries.
  • Data alignment.
  • Rank and Sort.
  • Summary statistics.
  • Missing data.
  • Index Hierarchy.
  • • Reading and writing text files.
  • JSON with Python.
  • HTML with Python.
  • Microsoft Excel files with Python.
  • Merge.
  • Merge on Index.
  • Concatenate.
  • Combining Data Frames.
  • Reshaping.
  • Pivoting.
  • Duplicates in DataFrames
  • Mapping.
  • Replace.
  • Rename index.
  • Binning.
  • Outliners.
  • Permutation.
  • GroupBy on DataFrames
  • GroupBy on Dict and Series.
  • Aggregation.
  • Splitting, Applying and combining.
  • Cross Tabulation.
  • Installing Seaborn.
  • Histograms.
  • Kernel Density estimate plots.
  • Combining plot styles.
  • Box and Violin plots.
  • Regression Plots.
  • Heat maps and clustered matrices.
  • Introduction to SQL with Python.
  • SQL SELECT, DISTINCT, WHERE, AND & OR.
  • • SQL WILDCARDS, ORDER BY, GROUP BY, and Aggregate Functions.
  • Introduction.
  • ER Diagram.
  • Schema Design.
  • Normalization.
  • SQL SELECT statement.
  • SQL SELECT using common functions.
  • SQL JOIN overview.
  • INNER JOIN.
  • LEFT JOIN.
  • RIGHT JOIN.
  • FULL JOIN.
  • SQL best practice.
  • INNER JOIN Advanced.
  • INNER JOIN and LEFT JOIN combo.
  • SELF JOIN.
  • JOINS and AGGREGATION Subqueries.
  • Sorting.
  • Independent Subqueries.
  • Co related Subqueries.
  • Analytic function.
  • Set operations.
  • SQL views.
  • Create a view.
  • Create a view using DDL.
  • SQL insert Advanced Technique.
  • Insert to create table.
  • INSERT to new data on existing table 1.
  • INSERT to new data on existing table 2.
  • INSERT to new data on existing table 3
  • INSERT to new data on existing table 4.
  • SQL update Advance technique and TCL.
  • SQL delete and TCL.
  • SQL constraints.
  • SQL aggregations.
  • SQL programmability.
  • SQL query performance.
  • SQL Extras.
  • Data wrangling with Excel
  • Microsoft Excel fundamentals.
  • Entering and editing texts and formulae.
  • Working with basic Excel functions.
  • Modifying an Excel worksheet.
  • Formatting data in an excel worksheet.
  • Inserting images and shapes into an Excel worksheet.
  • Creating Basic charts in Excel.
  • Printing an Excel worksheet.
  • Working with an Excel template.
  • Working with an excel list.
  • Excel list function.
  • Excel data validation.
  • Importing and exporting data.
  • Excel pivot tables.
  • Working with excels PowerPivot tools.
  • Working with large sets of Excel data.
  • Conditional function.
  • Lookup functions.
  • Text based functions.
  • Auditing and Excel worksheet.
  • Protecting Excel worksheets and workbooks.
  • MasteringMasteringExcelExcel"What"What--if?"if?"Tools?Tools?
  • Automating Repetitive Tasks in Excel with Macros.Automating Repetitive Tasks in Excel with Macros.
  • Macro Recorder Tool.Macro Recorder Tool.
  • Excel VBA Concepts.Excel VBA Concepts.
  • Advance VBA.Advance VBA.
  • Preparing and Cleaning Up Data withPreparing and Cleaning Up Data withVBA.VBA.
  • VBA to Automate Excel Formulas.VBA to Automate Excel Formulas.
  • Preparing Weekly Report.Preparing Weekly Report.
  • Working with Excel VBA User Forms.Working with Excel VBA User Forms.
  • Importing Data from Text Files.Importing Data from Text Files.
  • Descriptive Analytics.
  • Inferential Statistics.
  • Hypothesis Test 1 & 2.
  • Covariance
  • Correlation.
  • Regression.
  • Conjoint & Discriminant Analysis.
  • Discrete Uniform Distribution.
  • Continuous Uniform Distribution.
  • Binomial Distribution.
  • Poisson Distribution.
  • Normal Distribution.
  • Sampling Techniques.
  • T Distribution.
  • Hypothesis Testing and Confidence Intervals.
  • Chi Square Test and Distribution.
  • Bayes Theorem.
  • Talking about Business Intelligence.
  • Tools and Methodologies used in BI.
  • Why Visualization is getting more popular.
  • Why Tableau?
  • Gartner Magic Quadrant of Market Leaders.
  • Future business impact of BI.
  • Let's Explore…
  • Tableau Products.
  • Tableau Architecture.
  • BI Project Execution.
  • Tableau Installation in local system.
  • Introduction to Tableau Prep.
  • Tableau Prep Builder User Interface.
  • Data Preparation techniques using Tableau Prep Builder tool
  • How to connect Tableau with different data source.
  • Visual Segments.
  • Visual Analytics in depth.
  • Filters, Parameters & Sets.
  • Tableau Calculations using functions.
  • Tableau Joins.
  • Working with multiple data source (Data Blending).
  • Building Predictive Models.
  • Dynamic Dashboards and Stories.
  • Sharing your Reports.
  • Tableau Server.
  • User Security.
  • Scheduling
  • PDF File.
  • JSON File.
  • Spatial File.
  • Statistical File.
  • Microsoft SQL Server.
  • Salesforce
  • AWS
  • Azure.
  • Google Analytics.
  • R
  • Python
  • Hadoop
  • OneDrive
  • Microsoft Access.
  • SAP HANA.
  • SharePoint.
  • Snowflake.
  • Subject
  • Planning.
  • Pen & Paper approach.
  • Tools
  • Color theme.
  • Shapes
  • Fonts
  • image Selection.
  • text position.
  • visual placing.
  • Story layout & design.
  • Dashboard planning.
  • Power BI introduction and overview.
  • Key Benefits of Power BI.
  • Power BI Architecture.
  • Power BI Process.
  • Components of Power BI.
  • Power BI Building Blocks.
  • Power BI vs other BI tools.
  • Power Installation.
  • Overview of Power BI Desktop.
  • Data Sources in Power BI Desktop.
  • Connecting to a data Sources.
  • Query Editor in Power BI.
  • Views in Power BI.
  • Field Pane.
  • Visual Pane.
  • Custom Visual Option.
  • Filters.
  • Introduction to using Excel data in Power BI.
  • Exploring live connections to data with Power BI.
  • Connecting directly to SQL Azure, HD Spark, SQL
  • Server Analysis Services/ My SQL.
  • Introduction to Power BI Development API.
  • Import Power View and Power Pivot to Power BI.
  • Power BI Publisher for Excel.
  • Content packs.
  • Introducing Power BI Mobile.
  • Power Query Introduction.
  • Query Editor Interface.
  • Clean and Transform your data with Query Editor.
  • Data Type.
  • Column Transformations vs Adding Columns.
  • Text Transformations.
  • Cleaning irregularly formatted data Transpose.
  • Date and Time Calculations.
  • Advance editor: Use Case.
  • Query Level Parameters.
  • Combining Data Merging and Appending.
  • Data Modelling.
  • Calculated Columns.
  • Measures/New Quick Measures.
  • Calculated Tables.
  • Optimizing Data Models.
  • Row Context vs Set Context.
  • Cross Filter Direction.
  • Manage Data Relationship.
  • Why is DAX important?
  • Advanced calculations using Calculate functions
  • DAX queries.
  • DAX Parameter Naming.
  • Time Intelligence Functions.
  • Types of visualization in a Power BI report.
  • Custom visualization to a Power BI report.
  • Matrixes and tables.
  • Getting started with color formatting and axis properties.
  • Change how a chart is sorted in a Power BI report.
  • Move, resize, and pop out a visualization in a Power BI report.
  • Drill down in a visualization in Power BI.
  • Drill Through.
  • Histograms
  • Basic Area chart.
  • Combo Chart in Power BI.
  • Customize visualization title, background, and legend.
  • Doughnut charts in Power BI.
  • Scatter Charts in Power BI.
  • Funnel charts in Power BI.
  • KPI Visuals.
  • Radial Gauge charts in Power BI.
  • Bookmarks in Power BI.
  • Slicers in Power BI.
  • Filters
  • Report Level Parameters.
  • Z Order.
  • Waterfall charts in Power BI.
  • Create a Power BI dashboard.
  • Dashboard tiles in Power BI.
  • Pin a tile to a Power BI dashboard from a report.
  • Pin an entire report page to a Power BI dashboard.
  • Data alerts in Power BI service.
  • Add an image, text box, video, hyperlink or web code to your dashboard.
  • Configuring a Dashboard.
  • Power BI Q&A.
  • Display a dashboard tile in Focus mode.
  • Power BI embedded.
  • Row Level Security in Power BI.
  • Report Server Basics.
  • Refresh a dataset created from a Power BI Desktop file local.
  • Refresh a dataset created from a Power BI Desktop file cloud.
  • Web Portal.
  • Paginated Reports.
  • Data Gateways.
  • Scheduled Refresh.
  • Resources (Rest API/ SOAP API’s/ URL Access).
  • R Integration in Power BI Desktop.
  • R Powered Custom Visuals.
  • Creating R visuals in Power BI.
  • R Visuals in Power BI Service.
  • R Scripts Security.
  • Creating visual using Python.
5.00 out of 5.0
1 Star 0.0%
2 Star 0.0%
3 Star 0.0%
4 Star 0.0%
5 Star 100.0%
Amit Bose

Having 11+ years of experience in Data Analytics ,Power BI, Tableau, SQL, Excel. Worked in various product and service based Company. Having an experience of 4+ years in educating people and helping them to make a career transition.

Reviews

Nikhil Singh
July 11,2021
5.00

" Superb content, Amit Bose Sir recording is incredible. Assignments will build your concrete concept. You will be able to implement any project. Thanks to Amit Sir, Sudhanshu Sir, and Krish Sir. "

Syed Rehan
March 16,2021
5.00

" Great content and lot of exercises + assignments to practice. #HappyLearning :) "

Nitesh Kumar
February 25,2021
5.00

" When will this course start? "

Submit Reviews

You can not rate this course before login

Join Thousand of Happy Students!

Subscribe our newsletter & get latest news and updation!