Tra| Data for Better Business Decisions
Sai Prudhvi Neelakantam
Projects
Data Science & Business Intelligence
A comprehensive collection of projects in Azure, Databricks, Fabric, Power BI and key Data Science concepts like AI, Python, SQL, and Machine Learning
Courses & Certifications
A Showcase of my certifications in the fields of Data Engineering, Data Science, Business Analytics, and Business Intelligence
A Message From SAI
Join the community and receive all the news directly in your inbox!
LATEST ARTICLES
Community Talks
UPCOMING TALKS
Kansas City SQL Server Users Group
How to successfully deploy Advanced AI models on Azure Cloud?
📅 Monday, June 3rd, 2025, 12:45 AM CEST
Data Community Day Austria 2025
Near-Real-Time Object Recognition using Azure AI and Microsoft Fabric
📅 Friday, January 24th, 2025, 1:45 PM - 2:45 PM CEST
PAST TALKS
Microsoft Fabric Café
Medallion in Fabric: End-to-End Use Case
📅 Saturday, September 14th, 2024, 5:00 PM CEST
Microsoft Fabric Global Online Conference
Real-Time Object Recognition using Azure AI and Medallion within Microsoft Fabric
📅 Tuesday, September 10th, 2024, 8:00 PM CEST
Data Toboggan - Cool Runnings 2024
Near-Real-Time Object Recognition using Azure AI and Microsoft Fabric
📅 Saturday, July 13th, 2024, 12:00 PM CEST
Data Saturday Stockholm 2024
UFO Unearthed: Data Adventures with Databricks, AI and Power BI
📅 Saturday, May 25th, 2024, 9:30 AM CEST
New Stars of Data #7
UFO Unearthed: Data Adventures with Databricks, AI and Power BI
📅 Friday, April 5th, 2024, 11:30 AM CEST
Courses & Certificates
Databricks Certified Data Engineer Associate
As a Databricks Certified Data Engineer Associate, I have proven my expertise in advanced data engineering using Databricks and its capabilities. This certification underscores my ability to handle complex tasks related to Apache Spark, Delta Lake, Databricks, Lakehouse, Delta Live Tables, and more. My skill set includes designing and managing data pipelines, executing ETL processes, and leveraging SQL and Python for production-ready data solutions.
Microsoft Certified: Azure Data Engineer Associate
As a Microsoft Certified Azure Data Engineer Associate, I possess the knowledge and skills required to excel in the field. My expertise includes the design and implementation of robust data storage solutions, the development of efficient data processing pipelines, and the ability to secure, monitor, and optimize both data storage and processing systems. With this certification, I am equipped to make valuable contributions to data-centric projects, ensuring data integrity, performance, and security are always a top priority.
Microsoft Certified: Power BI Data Analyst Associate
As a Microsoft Certified Power BI Data Analyst Associate, I am equipped with the skills to transform, model, visualize, and deploy data-driven solutions. I am proficient in Power Query and DAX, and create insightful visualisations that empower self-service analytics and enable data-backed decisions. My expertise includes data quality assessment, security implementation, and collaborative data integration. With this certification, I offer actionable insights and valuable contributions to data-driven initiatives.
SQL Top 10% Examination Certificate
This certificate recognizes my outstanding performance in a SQL examination, where I placed among the top 10% of all test takers. It attests to my exceptional knowledge and skills in SQL, as well as my ability to solve complex problems in real-world scenarios. This certificate serves as an official recognition of my expertise and a testament to my commitment in the field of SQL.
Analyzing and Visualizing Data with Microsoft Power BI
This certificate acknowledges my successful completion of a Power BI course, where I learned to create dynamic reports and visualizations across large amounts of data using DAX formulas. The course provided a comprehensive overview of Power BI, starting from scratch and covering all the necessary steps involved in building a report. This certificate serves as an official recognition of my newfound skills and expertise in Power BI, and my ability to effectively analyze and present data.
Machine Learning Using SAS Viya
I have completed the 'Machine Learning Using SAS Viya' course, where I learned the theoretical foundation of supervised machine learning models. I gained hands-on experience in preparing, exploring, and selecting features for data analysis, as well as training and deploying advanced analytics models using SAS Viya's Model Studio. This certificate showcases my ability to apply a business-problem-solving approach to data analysis and make better decisions with big data.
Interactive Model Building using Visual Statistics on SAS Viya
I completed the SAS Data Manipulation Techniques course, where I learned advanced data manipulation skills using the SAS DATA step and procedures. I gained expertise in controlling DATA step processing, creating accumulating columns and grouping data, manipulating data with functions, converting column types, creating custom formats, concatenating and merging tables, processing repetitive code, and restructuring tables. This course built upon my SAS Programming 1: Essentials knowledge and further developed my ability to access, transform, and summarize data.
Advanced-Data Manipulation using SAS Programming
I completed the SAS Data Manipulation Techniques course, where I learned advanced data manipulation skills using the SAS DATA step and procedures. I gained expertise in controlling DATA step processing, creating accumulating columns and grouping data, manipulating data with functions, converting column types, creating custom formats, concatenating and merging tables, processing repetitive code, and restructuring tables. This course built upon my SAS Programming 1: Essentials knowledge and further developed my ability to access, transform, and summarize data.
Advanced-Visual Analytics on SAS Viya
I have completed a course in Advanced SAS Visual Analytics which taught me to use the tool for various advanced data preparation, analytics, and reporting tasks. I am now skilled in using automated explanation, restructuring data, performing advanced geographic, forecasting, network, path, and text analyses, and creating advanced data items, filters, and interactive reports with parameters.
Projects
-SAS-
Using SAS VIYA - Data Studio, Visual Analytics & Statistics, Build & Publish Models, Intelligence Decisioning, Code & Flows etc.,
Maximised Customer Value: Advanced Segmentation and Targeted Business Strategies for Telenor Norway
Consulted Telenor Norway and analysed customer data to identify segments and developed customised business recommendations to acquire and retain customers using machine learning and clustering algorithms on SAS Viya and Python
Using SAS Viya and Python, we analysed Telenor's customer data and applied advanced machine learning techniques to create customised business strategies that maximised customer value. Our data analytics techniques helped us identify new customer segments, enabling us to craft targeted campaigns and optimised customer service experiences.Telenor was highly-satisfied with our outcomes and implementation, with our customised business recommendations successfully integrated into their existing model pipeline, resulting in a significant impact on Telenor's product-driven approach, customer segmentation, buying patterns, behaviour-based clusters and revenue
-Python-
Using libraries like Numpy, Matplotlib, Pandas, Plotly, Requests, Scikit-learn, etc.,
Predicting Fraud: Real-Time Money Laundering Prediction Using Machine Learning
Real-time fraud detection for mobile money transfer service in Kenya using Gradient Boosting Machine Learning Model with scikit-learn.
This project involved developing a real-time fraud detection system on a FinTech company's data for mobile money transfer service in Kenya, using machine learning techniques. The project utilized the Gradient Boosting model from the scikit-learn Python library for the highest performance. The final model was recommended to be deployed with a threshold of 0.6, which achieved a 40% higher profit than the baseline model. Additionally, the fraud detection costs were reduced by 42%. The project also focused on addressing both technical and ethical issues in the development and deployment of the model.
Social Network Analysis: Social Strategies of Norwegian Politicians on Twitter
Social Network Analysis on Twitter data using web scraping, data analysis, and visualization techniques. REST API and JSON were deployed with Python libraries, and the project showcased expertise in data wrangling, network analysis, and visualization.
Exploring social relationships between Norwegian parliament members on Twitter through web scraping, data processing, analysis, and visualization with Python, Excel, Tableau, and Gephi. Utilized REST API and JSON with the Requests and JSON Python libraries for web scraping. Employed Pandas and Numpy Python libraries for data wrangling and manipulation, and performed exploratory data analysis using Matplotlib libraries. Demonstrated proficiency in network analysis, including homophily, E-I Index, party-level connections, reciprocity, and preferential attachment, and used Gephi to explore complex relationships between parliament members on Twitter.
Predictive Credit Card Default: Credit Defaulter Prediction using Machine Learning
Credit default prediction using machine learning algorithms like Random Forest, and Python libraries like Pandas, Numpy, and Scikit-learn.
Utilized advanced machine learning techniques, including data cleaning, feature engineering, and model tuning, for developing a predictive model to identify credit card default on mid-sized Nordic bank data.
Achieved 85% accuracy utilizing popular Python libraries such as Pandas, NumPy, Scikit-learn, and the Random Forest machine learning algorithm, demonstrating the effectiveness of predictive analytics to drive business insights and outcomes.
-SQL-
Hands-on topics like Database Modelling, DDL, DML, Schemas, CTEs, JOINs, Sub Queries, etc.,
8-Week SQL Challenge: Exploring the Power of SQL through Business Cases
This showcases Danny Ma's 8-week SQL Challenge, featuring a new case study each week with business questions solved using SQL.
Danny Ma's 8-Week SQL Challenge equipped me with essential SQL skills for data analysis, including filtering and ordering data, using JOIN operations, CTEs and subqueries, analyzing data with summary statistics and exploratory data analysis, and manipulating date and timestamp data. Additionally, I gained expertise in joining complex tables, creating different types of table indexes, and loading and transforming raw data. I used SQLite3, T-SQL and Azure Data Studio for databasing.As a business analyst, these skills enable me to analyze real-world business cases and provide valuable insights.
-azure-
Hands-on popular Azure Compute, Databases, Developer tools, Identity management and governance products.
Azure AD Administration: Optimizing Azure AD for Publishing Web Reports on Power BI Embedded
Demonstrating skills in Azure Active Directory Administration, Azure SQL Deployment, Power BI integrations and Web Embedding.
In this project, I demonstrated my skills in Azure Active Directory administration by deploying an Azure SQL database and integrating it with Power BI. After performing data analysis in I published the reports in the Power BI workspace and assigned web publishing access which allowed me to publish them on an HTML web page. In addition, I assigned various roles and access permissions to users in the Azure Admin portal, enabling authorisation control based on role levels within the organisation.This project showcased my skills in Azure AD administration, Azure SQL deployment, Power BI reports, and web embedding, which I can leverage in future projects.
-POWER BI-
Various visualisation projects including Data Modelling, DAX & Power Queries, Database Connectors, Data Flows, etc.,
Looking for a Ski Resort for your Next Winter Vacation?
A Dynamic PowerBI CV of a Business Analyst
The Ultimate FIFA Fanatic Dashboard
GeekInData Privacy Policy
Effective Date: 01/04/2024
Geekindata.com ("we," "us," or "our") respects the privacy of our users ("you" or "your"). This Privacy Policy describes the types of information we collect from and about you when you visit our website (the "Website") and how we use that information, in accordance with the General Data Protection Regulation (GDPR).Information We May Collect:
We may collect several different types of information for various purposes to improve our services to you. We will only collect and process data that is necessary for these purposes and will strive to minimize the data we collect.Personal Information:
We may collect personal information, such as your name, email address, and other contact details, when you:
- Register for an account
- Subscribe to our newsletter
- Contact us
- Participate in surveys or contests (optional)
- Usage Data: We may also collect information about your activity on the Website, such as the pages you visit, the links you click, and the searches you conduct. This data may be collected using cookies and other tracking technologies. You can control the use of cookies by adjusting your browser settings (see "Your Choices" below).Legal Basis for Processing:
We will only process your personal information based on a lawful basis as defined by the GDPR. These bases may include:Consent:
You may give us your consent to collect and process your personal information for a specific purpose, such as sending you newsletters. You can withdraw your consent at any time (see "Your Choices" below).Contract:
In some cases, processing your information may be necessary to fulfill a contract with you, such as providing access to a registered account.Legitimate Interests:
We may process your information for our legitimate interests, such as analyzing website usage to improve our services, provided these interests do not outweigh your rights and freedoms.Use of Information:
We use the information we collect for various purposes, including:
- To provide and operate the Website
- To process your requests and respond to your inquiries
- To personalize your experience on the Website (based on your browsing history, for example)
- To send you promotional emails and newsletters (with your consent)
- To improve the Website and our services
- To analyze how users use the Website (using anonymized data whenever possible)Sharing of Information:
We may share your information with third-party service providers who help us operate the Website and provide our services. These service providers are carefully selected and obligated by contract to:
- Protect your information
- Use your information only for the purposes we have specified
- Comply with all applicable data protection laws
- We may also disclose your information if required by law or to protect the rights, property, or safety of ourselves or others.
However, we will do so only in accordance with applicable legal requirements.Data Retention:
We will retain your personal information for as long as necessary for the purposes for which it was collected and processed, and in accordance with legal requirements. When your information is no longer needed, we will securely delete it.Your Choices:
You have several choices regarding your information:- Access and Rectification: You have the right to access your personal information and request rectification of any inaccurate data.- Erasure (Right to be Forgotten): You have the right to request the erasure of your personal information, unless there is a compelling reason for us to keep it (e.g., legal obligations).- Restriction of Processing: You have the right to restrict the processing of your personal information, meaning we can store it but not use it further.- Data Portability: You have the right to request a copy of your personal information in a machine-readable format and to transmit it to another service provider.- Object to Processing: You have the right to object to the processing of your personal information, particularly for marketing purposes.- Withdraw Consent: You can withdraw your consent to the processing of your personal information at any time.
To exercise any of these rights, please contact us using the information below.Data Security:
We take reasonable steps to protect your information from unauthorized access, disclosure, alteration, or destruction. These steps include:Secure storage of data:
- Regular security audits
- Use of encryption technologies
However, no Internet transmission is completely secure, and we cannot guarantee the security of your information.Changes to this Privacy Policy:
We may update our Privacy Policy from time
best ski resorts for your next winter vacation
With this SKI RESORT Power BI dashboard, skiers can filter resorts based on location, price, slopes, lifts, and seasons, and even view their locations on a map.
As a Business Analyst, I recently took on the Maven Slopes Challenge and used Power BI to build a user-friendly dashboard to help skiers find their ideal ski resort. I used several powerful tools like DAX, Power Query, and Power BI Visualizations to transform the dataset provided into meaningful insights. I'm proud to have completed this challenge and to showcase it in my portfolio.
The Ultimate FIFA Fan Dashboard
Introducing The Ultimate FIFA Fanatic Dashboard: Seamlessly explore teams' rankings, player stats, match outcomes, and championships.
In my capacity as a dedicated Business Analyst, I recently embraced the task of crafting the ultimate FIFA fan experience. By harnessing the prowess of Advanced DAX, Power Query, and Power BI Visualizations, I adeptly transformed intricate match data into an interactive dashboard. This accomplishment underscores my analytical finesse and penchant for data-driven insights, elevating my portfolio's caliber.