Narendra Kotha SQL & BI Developer
No reviews yet

Would you like to start your career with Data or BI (Business Intelligence) ?

Prerequisite : Basics with Excel is enough.

Efficient and Expert in SQL & BI tools like Power BI, Tableau, SSIS and SSRS. Have got 14 Years of IT experience in which 10 years of training experience with SQL & BI tools and we practice these courses through case studies in which you get an opportunity to work with real time data. While practicing with various scenarios you can gain hands-on knowledge on technical concepts of the course. Each session will be recorded and share with you after the session. Supporting sessions will be provided for Interview preparation and CV design before getting into job market.

Demo session can be arranged upon request and any questions regarding the course and other details will be discussed.
Courses Offering : SQL Server, Power BI, Tableau, SSIS and SSRS
Course Duration : 40 Hours (online training)
Course Offerings : Session Recordings, Practice files, CV & Interview preparation.
Course Combinations :
1). SQL Server, SSIS & SSRS
2). SQL & Power BI
3). SQL & Tableau

Subjects

  • SQL Beginner-Expert

  • Power BI Beginner-Expert

  • Tableau Beginner-Expert

  • SSRS, SSIS, SQL Server Beginner-Expert

Experience

  • BI Developer (Oct, 2010–Present) at XXXXXXXXXX Org name can be disclosed in person XXXXXXXXXXXX
     Having 14 Years of IT Experience in developing and supporting SQL DB, DW & BI Applications using Microsoft BI tools (SSIS, SSRS and SSAS) and Power BI, Tableau, Qlik.
     Experience with T-SQL in constructing Stored Procedure, Functions, Views, Dynamic Query, Exception Handling, Triggers, Cursor writing, Transaction control.
     Writing complex T-SQL queries using Inner, Outer and Cross Joins.
     SQL Server Integration Services (Package creation, Check Points implementation, Dynamic Configuring of package, Logging, Custom script writing, Package deployment using Manifest, Implementing Transactions, Package encryption.)
     SQL Server Reporting Services (Generating reports in the form of Tabular, Matrix, Chart and List Data Region from OLTP and OLAP Data bases, grouping and sorting, formatting, parameters including Cascading, DrillDown, Sub and Linked Reports, Security and deployment.)
     SQL Server Analysis Services (Cube Creation, Knowledge on OLAP and designing Cubes, Populating data, Knowledge on writing MDX Queries.)
     Strong Knowledge in creating and developing Power BI Dashboards in to rich look.
     Strong Knowledge on Power BI to import data from various sources such as SQL Server, Excel, CSV and few traditional source systems
     Knowledge on Power BI Visuals including Tree Map, Funnel, Line Chart, Map Reports, Stacked Reports, Divergent & Sentiment Properties
     Having great knowledge about ETL using various tools and explained various examples with Power Query. Mentioned differernce of options over other ETL tools like SSIS, Prep.
     Good Knowledge on Power Query (M Language) Functions, Power Query Parameters, Variables, Power Query Lists, Tables and Records.
     Got good knowledge of Data Modeling implementation in genral and guide better ways to introduce in Power BI with great examples.
     Very good Knowledge on DAX Functions, DAX Measures and Calculations.
     Best practices & Industry standards for Dashboard designing in Power BI.
     Hands on experience on Tableau Desktop 7/8.2, Tableau Reader and Tableau Server.
     Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data
     Good knowledge over Advanced viz in Tableau like heatmaps, tree maps, box plots etc…
     Writing calculations and formulas in Tableau and functions (aggregation, logical, date, etc.)
     Tableau parameters & Interactive features
     Hands-on knowledge on Tableau Prep an ETL tool for Tableau
     Cleaning and shaping data using Tableau Prep.
     Tableau Server and Sharing, Publishing workbooks to Tableau Server
     Managing permissions & user roles, Scheduling, and refreshing data extracts
     Having knowledge on Python
     Experienced in Qlikview reporting functionalities such as Incremental load, Generic load, Cross table, Partial load, Sorting, QVD, Section Access, Variables, Procedures, and Macros.
     Conducted Training Sessions on SQL Server & MS-BI technologies to Trainee Associates.
     Enthusiast and Experienced BI developer- the pioneered in-memory Dash boarding tool.
     Knowledge of AGILE methodology and Capable of performing under minimal supervision, multi-tasking, meet deadlines as an individual contributor and a committed team player with good communication skills.

Education

  • Master of computer Applications (Aug, 2007–May, 2010) from ANDHRA uNIVERSITY

Fee details

    ₹600–800/hour (US$7.14–9.51/hour)

    I will take USD $300 (Negotiable) for Power BI course and I will support with Session Recordings, CV and Interview preparation as well.

Reviews

No reviews yet. Be the first one to review this tutor.