Posts

Six qualities of a great Data Scientist

What does it take to be a great data scientist?  Some of these you undoubtedly know without looking, but others may surprise you. These six hard and soft skills are not just things to look for in a data science hire, but are also things to cultivate in yourself to prepare for a successful and fulfilling career in data science. 1. Statistical thinking Data scientists are professionals who turn data into information, so statistical know-how is at the forefront of our toolkit. Knowing your algorithms and how and when to apply them is arguably the central task to a data scientist's work. However, to do this well can be an art and a science. A good data scientist can model any data he is given and implement a toolbox full of algorithms to make statistically-informed predictions and recommendations. A great data scientist can smell something 'fishy' in the results she gets, senses that he needs to ask the client or stakeholder a few more questions before retreati

Excel Key Features to learn for a Data Analyst

Learning Advanced Excel - Needed to Explore Data, understand patterns & themes on the data... Below will help you become a good Data Analyst on Excel What is Latest Excel Version  Maximum Rows & Columns Calculated Columns Casting / Conversion of Data Types Especially working Text to Numbers, Extracting Year, Month, Date from a single datetime or date column Converting / changing / bringing a single time zone for multiple timezone data String operations - Extracting only a portion of your value Statistical Functions in Excel Banding a value available in a single column Pivot Tables - SO IMPORTANT and need to go deep into various features available on a Pivot Table Pivot Charts Using Slicers with Pivot Tables Using Filters with Pivot Tables Using Sorting inside Pivot Tables Moving around Rows & Columns and understanding themes in your data VLookup HLookup When to use Lookups Bringing values / columns from multiple excel sheets into a single sheet W

Learning Power BI - Keywords, Key Topics to learn and useful links

 1) Keywords - you should know what each of these mean, when you learn PBI. Power BI Licensing: Free, Pro, Premium Power BI Cloud and Power BI On-Premise (Power BI Report Server) Power BI Desktop and how to use it Ways to bring in data - Import Data, Direct Query and Live What is SSAS Tabular and why PBI with SSAS Tabular model is great combination Size limitations when you do Import Data # of times you can refresh data in a day  - when you do Import Data Building Blocks of PBI - DataSets, Dashboards, Reports, Tiles, Visualizations Slicers Filters and difference with Slicers What is DAX and DAX Expressions  Custom Columns Custom Measures and difference with Custom Columns Data Modeling within PBI Desktop Certain basic business expectations - how do you do it in PBI - Bringing in YTD, MTD, Doing Trends, Comparing YoY, MoM Using Maps Using InfoGraphics Custom Visuals and how to use them SQL Server latest version SQL Server various Editions Writing basic

Comparison of Power BI Service vs. Power BI Report Server vs. SQL Server Reporting Services

Image
Comparison of Power BI Service vs. Power BI Report Server vs. SQL Server Reporting Services Following is a summary of the key feature differences available when deploying to the cloud-based Power BI Service vs. the on-premises report deployment options (this is not an exhaustive list of all features). SQL Server Reporting Services (SSRS) is included only for comparison to the Power BI Report Server, as SSRS is beyond the scope of this whitepaper. Feature/Capability Power BI Service Power BI Report Server June 2017 SQL Server  2017 Reporting Services Publish and View Reports: Publish and view RDL (Reporting Services paginated report) Publish and view PBIX (Power BI report) Publish and view XLSX (Excel workbook) Rendering of custom visuals utilized in a PBIX Use of native mobile applications (iOS, Android, Windows) APIs for embedding reports in a custom application Data Sources and Data

Why SharePoint Online is a much smarter choice than SharePoint On-Premise!

Security, is way tighter in SPO infact – and some features do not even exist in SP On-Premise. For instance, with SPO: 1.       You get the ADFS integration – which means, you can take advantage of the ADFS features & security policies, location based control for SPO as well 2.       RMS – Rights Management Services – Azure RMS – is pre-configured in SPO and supports file types such as MS Office, PDF files, Images too – and all you need is the Azure Information Protection Client to view the protected files 3.       You get DLP (Data Loss Prevention) which is only available with SPO and I have created a presentation for this  here  – Have a look and using this, we can prevent confidential content such as documents containing patents, SSN numbers or SWIFT Codes or IP Addresses can be protected from going out 4.       SPO Content has multiple times encrypted and hence, the content is way secure than you can imagine 5.       On top of it, you can even prevent SPO Site

10 Skills Every SharePoint Developer Needs

This blog post guides you through the essential skills for a successful SharePoint developer. Great SharePoint developers know how to use scripting, design, and drafting tools. They have knowledge of out of the box features that don’t necessarily need customization. This list includes the addition of a few personal attributes too. 1. KNOW THE OUT OF THE BOX TOOLS AVAILABLE TO A SHAREPOINT DEVELOPER This is the skill required above all else. You can be interviewing an amazing .NET developer who really knows their stuff, but never worked specifically in SharePoint. Unfortunately hiring him would be a huge fail on your part. SharePoint development is an odd beast and even someone who has top notch skills in all of the below mentioned areas, but no real understanding of SharePoint will fall on their face when attempting to tackle your project. Find someone who can talk SharePoint with you and prove experience using the following Windows-specific tools: 1.       Out of the box f

Multi Factor Authentication, Conditional Access for Power BI

There is always a discussion on protecting Power BI access, enabling MFA, conditional access etc. This is very much possible. Please refer this article. https://powerbi.microsoft.com/en-us/blog/secure-and-audit-power-bi-in-your-organization/ I have attached a PPT with screenshots of how this works (infact, I have taken it from iGrid’s Azure Subscription) Using certain configuration, you can even block access for users, when they are not at work. Infact, you can have such a configuration done for every O365 product. You would require Azure AD Premium P1 for this and different plans are here: https://www.microsoft.com/en-us/cloud-platform/azure-active-directory-pricing This could approximately cost $6/user/month.