Archives categorized by Year
Archives categorized by Month
List of ALL Blog-posts:
- ALL THINGS DATA NEWSLETTER #17
- 3 prioritization frameworks
- What does Analytics People Manager spend their time on?
- All things data newsletter #16
- Three stories about my managerial journey published on Plato
- All things Data Newsletter #15 (#dataengineering #datascience #data #analytics)
- All things Data Newsletter #14 (#dataengineering #datascience #data #analytics)
- All things data newsletter #13 (#dataengineer #datascience)
- Framework for onboarding as an Analytics leader in a new team:
- All things data newsletter #12 (#dataengineer #datascience)
- Making your engineering team more data-driven
- All things data newsletter #11 (#dataengineer, #datascience)
- All things data newsletter #10 (#dataengineer #datascience)
- All things data newsletter #9 (#dataengineer, #datascience)
- All things Data Engineering & Data Science Newsletter #8
- All things data engineering & science newsletter #7
- Data Engineering and Data Science Newsletter #6
- Data Engineering and Data Science Newsletter #5
- Data Engineering and Data Science Newsletter #4
- INSIGHT EXTRACTOR’S DATA ENGINEERING AND SCIENCE NEWSLETTER #3
- Insight Extractor’s Data Engineering and Science Newsletter #2
- Business Analytics Continuum: Descriptive, Diagnostic, Predictive, Prescriptive
- Insight Extractor Newsletter #1
- Four Tenets for effective Metrics Design
- Five Tenets for effective data visualization
- Data Culture Mental Model.
- [Resource] Research on Data Use in Business
- 5 stages of Analytical Competition
- How Analytics changed Scouting in Soccer
- [Career Advice] What are the downsides of working as a data scientist in Silicon Valley?
- Great example of storytelling through data:
- Two great posts on DAU/MAU and Measuring Power Users
- Excel 2013: Display hidden rows columns and data on an Excel Chart
- Framework to evaluate great companies from “Good to Great” book by Jim Collins:
- An easy way to remember: Vision, Mission & Strategy
- Springboard Data Analytics for Business Office Hours
- News: PASS outstanding Volunteer award & stepping down as Business Analytics Virtual Group Co-leader
- What is the difference between courses offered by Springboard vs datacamp vs dataquest? Which is better?
- #PowerBI idea: Enable #PowerQuery Excel add-in for Mac/Apple/iOS
- Rumsfeld on Analytics:
- How will bots impact the adoption of data platforms?
- What are the must-know software skills for a career in data analytics after an MBA?
- Is it too late to become a good Data Scientist?
- As a data scientist, are you dissatisfied with your career? Why?
- How do you become a good data analyst?
- [Resource] 8 Methods to calculate CLV:
- How does rise of Power BI & Tableau affect SSRS?
- 5 tests to validate the quality of your data:
- Journal of statistical software paper on tidying data:
- As a student preparing for data anaylst & science roles, should I generalize vs specialize?
- Any advice for moving into data science from business intelligence?
- In how many dimensions (Vs) is Big Data commonly defined?
- How do I learn #SQL for #data analysis?
- Single variable linear regression: Calculating baseline prediction, SSE, SST, R2 & RMSE:
- SQL: How to add Hierarchical Levels in your Query?
- Is the R data science course from datacamp worth the money?
- Data analytics vs. Data science vs. Business intelligence: what are the key differences/distinctions?
- Where can I find a data analyst mentor, be it in-person or online?
- Looker vs Tableau: How would you compare them in terms of price & capabilities?
- Cheat Sheet to Pick the right graph or chart for your data:
- How can I start learning and exploring the field of Big Data Algorithms?
- Where do data scientist hang out online?
- What analytics data gives you the most actionable advice to improve your blog?
- Introduction to SQL Performance Tuning for Data Analysts
- What are some of the most important resources a Data analyst needs to know about?
- Introduction to Goal Seek & Solver capabilities in Excel:
- As a data analyst for the CEO in an e-commerce company, what kind of reports are expected of me?
- How to remove line feeds (lf) and character return (cr) from a text field in SQL Server?
- How do I pursue career in data warehousing?
- How Marketable is R programming?
- How do you generally detect a fraud using analytics?
- What’s a good chart making software that can pull online data?
- Can I be a data analyst at a tech company without a degree in computer science?
- Book Giveaway: Head First Data Analysis — Ends 07/22/2016
- How to create a Histogram in Excel?
- What are the reasons why developing a data dictionary is so important?
- How do I get experience as an entry-level Data analyst?
- What data are data scientists at startups actually analyzing? How is it collected?
- What is the difference between Histogram & Bar Chart?
- [Video] AI, Deep Learning and Machine Learning
- What is the title these days for a person that assures data quality?
- What is the difference between Row_Number(), Rank() and Dense_Rank() in SQL?
- What are the differences between big data developer and data analyst?
- What is Descriptive Analysis?
- Does data analysis and machine learning go hand-in-hand or are they mutually exclusive activities?
- Why are there so many analytics startups?
- How do I prepare myself to be a data analyst?
- Why you should use “Tune Model Hyper parameters” module in Azure Machine Learning?
- “4W” framework for assessing your Analytics Maturity:
- Amazon ML vs Microsoft Azure ML vs Databricks Cloud — my guest post comparing cloud Machine Learning platforms on BigDataCloud.com
- As a prospective Data Analyst intern, how do I answer the most challenging data analysis I have done so far?
- Are Dashboards dead?… #Analytics
- Webinar: Learn how to build a Machine Learning model to predict customer churn
- Completed Marketing Analytics Course from Coursera:
- Machine Learning Algorithm Cheat Sheet:
- Building data driven companies — 3 P’s framework.
- Doing Data Science at Twitter — A great read!
- 500 posts! New Blog Domain name = InsightExtractor.com!
- [VIDEO] Microsoft’s vision for “Advanced analytics” (presented at #sqlpass summit 2015)
- SQL Server Reporting services: How to display “There are NO rows” message?
- How to change the Data Source of a SQL Server Reporting Services Report (Native Mode)?
- Back to Basics — What is DDL, DML, DCL & TCL?
- How to fix the Non-unicode to unicode data type conversion problems in SQL Server Integration Services?
- Titanic Data
- Productivity Tip: Learn to Comment/Uncomment SQL code using shortcuts
- Qlik sense: How to see Data Load Editor scripts for apps developed by your Team members?
- Data puking and how T-mobile alienated a potential customer:
- How to add Sparkline data visualization to Google spread sheets?
- Data -> Insights -> ?
- PASS Business Analytics VC has grown 123% in a year! #sqlpass @passbavc
- How to add custom User-ID to your Universal Analytics (Google) implementation?
- An amazing framework to solve business problems:
- What percentage of users are authenticated? (Google Universal Analytics)
- A key driver for business intelligence adoption: Embedded analytics.
- SQL: How to get first/last transaction details for each user account?
- PASS Business Analytics conference 2015 – Keynote Day 1. #passbac
- How to analyze “new users” metric by specific pages in Google Analytics?
- How to assign same axis values to a group of spark-lines in Excel?
- Business Metric #6 of N: Net Promoter Score (NPS)
- Cohort Analysis: What is it and why use it?
- Every Data Analyst Needs to check out this FREE excel add-in: Power Query!
- Achievement Unlocked! Passed Google Analytics certification Exam.
- Top 2 Data Analytics Techniques:
- Answering a question using data: Are marketers around the globe shifting their dollars to digital ads?
- #sqlpass webinar: “Data Analytics Explained for Business Leaders” on 1/15
- Five actions that you can take if you measure your analytics/business-intelligence solution usage:
- Example of using segmentation to identify low-margin service offerings:
- Live tweeted #sqlpass’s Business Analytics VC webinar: 13 Excel Tips!
- Dashboard – Asset management & planning for a global crisis response team:
- News from PASS Summit’14 for Business Analytics Professionals: #sqlpass #summit14
- Business Intelligence system – Customer Complaints – B2B company:
- Sales Bookings vs Quota Dashboard for a B2B company:
- Examples to help you differentiate between Business Intelligence and Data Science problems:
- How to get descriptive statistics in Excel?
- Cost Driver’s Dashboard for a Supply Chain Executive:
- PASS September 2014 Outstanding Volunteer
- Business Metric #5 of N: “Conversion rate” (online marketing)
- Business Metric #4 of N: “Leads” (marketing)
- Time Intelligence in MDX: last N days
- SQL Server Reporting Services Tip: How to capitalize just the first letter of text?
- Back to basics: Design your Business Intelligence system to have lowest level data even if it’s not asked!
- Business Intelligence Dashboard for Inventory management for a manufacturing organization:
- How does Internet of Things (#IoT) impact data professionals?
- PASS Business Analytics VC: Insider’s Introduction to Microsoft Azure Machine Learning (#AzureML). #sqlpass
- Back to basics: Multi Class Classification vs Two class classification.
- How to Configure SQL Server Analysis services’s Action to Open an URL?
- How to create an Average Aggregation in SQL Server Analysis services?
- SQL Server Analysis services warning: “The name specified for the attribute relationship differs from the name of the related attribute”
- SQL Server Analysis services warning: “The name specified for the attribute relationship differs from the name of the related attribute”
- Business Intelligene Dashboard for Quality Managers
- Business Intelligence Dashboard for Plant Managers (operations focused):
- Power Pivot: How to get Month Name from a date field?
- SSAS Joining Facts at different granularity to a single dimension:
- Achievement Unlocked: Tableau Desktop 8 Qualified Associate!
- SQL Server Query Fundamentals: A Simple example of a Query that uses PIVOT:
- Back to basics: continuous Vs. Discrete variables and their importance in Data Visualization.
- SSIS: Using Data Profiling Task to check the candidate key profile of unknown data source(s)
- PASS Business Analytics VC: 7 Ideas on Encouraging Advanced Analytics by Mark Tabladillo #sqlpass
- Business Intelligence Dashboard project for a Business Leader
- TSQL – Quick note about numeric data type to solve “Arithmetic overflow error”
- SSIS – How to use Execute SQL Task to assign value to a variable?
- SQL Server Analysis services – How to set the order by attribute sort key?
- Design pattern for making staging table loads incremental in SSIS:
- SQL Server Analysis Services (SSAS) multidimensional cube: How to create a role playing dimension?
- SSAS Multidimensional cube: How to solve duplicate attribute key error when attribute is non key?
- SQL Server Reporting Services: How to Solve Divide by Zero Errors?
- #sqlpass #msbi online event: “The Accidental Report Designer: Data Visualization Best Practices in #SSRS”
- SSAS Tabular: How to mark a table as Date Table?
- SQL server Integration services: How to solve “The value violated the integrity constraints for the column” error?
- SQL server analysis services MDX: Current Fiscal Period vs Previous year same Fiscal Period Query
- SQL Server Integration services: How to write a package that does Set based updates?
- Analyzing user survey data using Text Mining techniques for a Startup
- SQL server Analysis Services: How to import cube meta data to SQL server Data Tools?
- Business Metrics #3 of N: Inventory Turnover
- SQL Server reporting services: How to use the Split function in the SSRS expressions to get sub-string?
- SQL Server Analysis services MDX: How to write a query that works as LIKE operator in SQL?
- SQL Server reporting services: How to add a seconday axis on a chart?
- PASS Business Analytics VC Meeting–May 29
- SSAS Tabular Model: How to change the query used for tables?
- SQL Server reporting services: How to Add Trademark special symbol in Text?
- PASS Business Analytics Conference – Day #2 Keynote
- PASS Business Analytics Conference – Live Blogging: Day #1
- How to train your users to create their own Business Intelligence reports? #5 of 5: Post Training
- How to train your users to create their own Business Intelligence reports? #4 of 5: Sample Training Content
- Presented at #SQLSat 305 Dallas BA edition!
- How to train your users to create their own Business Intelligence reports? #3 of 5: User Experience, Trainer, Content
- How to train your users to create their own Business Intelligence reports. #2 of 5: Pre Training Prep
- How to train your users to create their own Business Intelligence reports. #1 of 5: Why do it?
- SQL Server Reporting Services: How to add Interactive Sorting to a Table with no groups?
- SQL Server Analysis Services MDX: How to display last/rolling 12 months trend in MDX?
- SQL Server reporting services: How to customize the Legend Text on a chart?
- SQL Server Analysis Services MDX: Sum of Last N Years, Quarters, Months, Periods.
- SQL Server Reporting Services: How to display Multi Select parameter selected on the report?
- SSAS MDX: How to hide null values for months in current fiscal year while comparing the value against last years numbers?
- Licenses required in Excel 2013 & Office 365 for Power View and/or Power BI:
- Where can you find key SSAS MDX cube objects in the Metadata pane?
- PASS BA VC: Analyzing Road Traffic Accident Data in #PowerBI by Chris Webb #sqlpass
- SSAS MDX Query: How to Return Top N products by revenue
- Questions Power Users Ask about Excel: #4 of N
- How to set SSRS date parameter default value to previous day?
- SSRS: How do I know where a report item is on the report?
- SQL Server: How to insert explicit values into an identity column of a table?
- How to use TSQL checksum to compare data between two tables?
- Quick note on evolution of Business Intelligence & Microsoft’s vision for BI space:
- Business Analytics VC event on 2/27: Microsoft SQL Server 2014 Countdown event!
- TSQL Script: How to get list of all tables or view in a database?
- Business Analytics VC: 13 Tips for KPIs with the Microsoft SQL/BI Stack
- Microsoft Self Service BI mentoring for an American Healthcare company
- SSAS MDX: Alias for a Measure Name
- SQL Spatial Data Types: A Tip to fix STIntersects Method returning NULL values.
- SQL Server Reporting Services: What are Drill Down & Drill Through reports?
- Notes from Atlanta SQL BI meeting: “Bus Matrix”
- Three Power Pivot Installation FAQ’s:
- Business Intelligence Project for an International Law firm
- #sqlpass business analytics VC event tommorow 16th Jan! “Analytics at Cisco”
- Time Intelligence in DAX: Last n days
- BI project for Digital Marketing agency: How to show value of social media marketing?
- SSRS: Why I prefer shared data source over embedded data source?
- SSRS Error: “The value expression for the … contains an error. [BC30451] ‘code’ is not declared”
- Questions Power Users Ask about Excel: #3 of N
- SSIS Error on opening a package: The connection “{GUID}” is not found. The error is thrown by connections collection when the specific connection element is not found
- Questions Power Users Ask about Excel: #2 of N
- Questions Power Users Ask about Excel: #1 of N
- How to strip double quotes while importing data from CSV or TSV using SSMS Import Data wizard OR SSIS?
- SSRS in SharePoint mode: Data alert & Subscribe are grayed out or disabled.
- How to embed or integrate Power View reports into SharePoint pages?
- PASS BA VC EVENT: Integrating SSRS with SharePoint on Nov 25th, Monday:
- Power Pivot DAX: Difference between two DATE values
- Power Pivot: Casting DateTime to Date in SQL Server source query
- A quick note on how select @@version helps me while I’m T-SQL’ing:
- Example of an DAX Substring Equivalent:
- Quick Note about the Filters in the Power View Report:
- Nice series on WordPress Blog Statistics:
- PASS Business Analytics VC’s Online Event: “Power BI Info Management and Data Stewardship”
- How to understand Business Logic from Excel 2010 Macros?
- A Note about “Edit Report” button seen on Power View reports in SharePoint:
- [Notes] Atlanta Business Intelligence User Group – Mapping Data in Power View & Tableau
- How to sort measure values in an excel 2010 based ad-hoc report using SSAS cubes?
- What Problems does Power BI solve?
- How to Flatten Data in Excel Pivot Table?
- What is the purpose of creating Tables & Graphs?
- How to add calculated measures to Pivot Tables using OLAP Pivot Table Extensions add-in?
- How to Change Data Source of an Excel 2010 Pivot Table?
- How to add additional Columns to an Existing Table in a Power Pivot Model?
- Book Review: Confessions of a public speaker
- How to Track SSAS cube usage by End-User Tool?
- Book Review: R in a Nutshell
- Using Excel as BI Tool? Consider 64-Bit version.
- SQL Server Reporting Services: How to Add Tool Tips to charts?
- SQL server reporting services: Expression to show current month name & year
- SSRS Email subscription: “SSRS Subscriptions cannot be created because the credentials used to run the report are not stored…”
- Gallery: Visualizing report execution logs data to understand what’s up with slow running reports.
- How to Parametrize a SSRS report where data source is Analysis services cube?
- Slicing/Dicing data in multiple Excel Pivot Tables with ONE slicer:
- How to change the layout of the Excel Pivot Tables?
- SQL Server Reporting Services: Why am I not seeing every axis label in a chart?
- SQL Server Reporting Services: Month Names sorting Issue
- Data Explorer is now “Power Query” AND yes, you can use with Excel 2010 Pro Plus!
- Custom Calculations for Invoice & Returns using PowerPivot DAX formula
- New Digital Marketing Analytics Report shows social media is not the best source of acquiring customers:
- Seven ways Analytics can create value in an Organization:
- Back to basics: Why do you need OLAP cubes/ Data-Warehouses for enterprise business reporting systems?
- A great example to show power of visualizing data: Anscombe’s Quartet Table
- PowerPivot DAX: Moving Average
- Exploring, filtering and shaping web-based public data using Data Explorer Excel add-in:
- Web Scraping Tables using Excel add-in Data Explorer preview:
- Getting Started: Implementing Dynamic Security with row filters in Tabular Models
- Upgrading PowerPivot Excel Add-in
- Excel 2010: How to check the installed version of PowerPivot and what’s the latest version?
- SQL Server 2014!
- Data Analysis and In Memory Technologies, let’s connect the dots:
- The role of Sentiment Analysis in Social Media Monitoring:
- How conditionally formatting your data in Excel can help you save time in answering business questions?
- Resource: Introduction to Data Science by Prof Bill Howe, UW
- Unpivoting data using the data explorer preview for Excel 2010/2013:
- Merging/Joining datasets in Excel using Data Explorer add-in
- Remove Duplicates in Excel Tables using Data Explorer Add-in:
- Business Analytics project is like an iceberg:
- How to solve common Data Quality Problems using Data Quality Services? (Part 1)
- PASS Business Analytics Conference Keynote Day #2
- PASS Business Analytics Conference Keynote Day #1
- Excel: Swapping (reversing) the Axis of a Table Data
- Tableau: Data Cleaning for Geographic Maps
- Business Metrics #2 of N: Customer Retention Rate
- Beginner’s Guide: Sentiment Analysis using Python on Windows
- Three Data Collection Tips for Social Media Analytics
- Data Reporting ≠ Data Analysis
- Guest Blog: How to measure ROI of Social Media Marketing?
- Business Metrics #1 of N: Customer Lifetime Value
- Three Data Visualizations I liked this week:
- Know who is Talking about YOU on the web – set up Google Alerts!
- An auto-refreshing Word Document that fetches data numbers from Excel:
- How to add secondary axis in a chart in Excel 2010?
- Received President’s Volunteer Service Award!
- Google Analytics: How to Track an email campaign?
- What’s “Naive” about Naive Bayes Machine Learning Algorithm?
- Recapping my social media activities during Jan 1 – Feb 24 2013:
- Resource: 12 recorded sessions from the 24hop business analytics edition are online! #passbac #msbi
- Sentiment Analysis using LingPipe on windows 7:
- Steps to Install Weka on desktop running windows OS:
- Found something interesting by exploring a “List of companies by revenue” Data Set:
- My First Five Toastmaster International club speeches:
- Data visualization: List of largest IT companies in the world
- Adding a TrendLine to a Time Series Line Chart in Excel 2010:
- Statistics 101: Nominal, Ordinal, Interval, Ratio Data
- Quick Note about SAS’s acroynm SEMMA:
- Trying out FLASH FILL which is a new Excel 2013 Feature:
- How many websites in USA exceed the data collection limitations of Google Analytics?
- Resource: A great tutorial for Hadoop on local windows and Azure.
- Event Recap: SQL Saturday 185 Trinidad!
- Presentation Tip: Change the Font Size of the Windows Command Prompt
- Back to basics: Data Mining and Knowledge Discovery Process
- Quick Post: Uploading Local Data to Hadoop file system using Hadoop Command Line
- Examples of Machine Generated Data from “Big Data” perspective:
- Download PPT: Why Big Data Matters?
- How to Install Microsoft .Net SDK for Hadoop?
- inner workings of HDFS and MapReduce in a nutshell:
- Data visualization: Cost of Hard Drive storage space
- How to start Analyzing Twitter Data w/ R?
- How to load some data to Hadoop on Windows to get started?
- Seven Demo’s for SQL Server 2012 Data Quality Services:
- How to create a MDS entity via Excel add-in?
- How to view error(s) that occur during Master data Service’s Staging Process?
- Hadoop on Windows: How to Browse the Hadoop Filesystem?
- Visualizing MapReduce Algorithm with an Example: Finding Max Temperature
- Microsoft® HDInsight Preview for Windows: How to use Sqoop to load data into HDFS from SQL Server?
- Microsoft® HDInsight Preview for Windows: How to create a directory in Hadoop File System?
- Neologism is the new challenge for IT professionals, Here’s why:
- Sentiment Analysis in R w/ Twitter data feeds
- Matching activity in Data Quality Services in action!
- Playing w/ the Occupational Employement Statistics Data-Set:
- Data Profiling and SQL Server 2012 Data Quality Services
- Data Quality Service’s Composite Domains in action!
- Things I shared on Social Media Networks during Noc 12 – Dec 31 (2012)
- In 2012, people from 162 contries visited ParasDoshi.com!
- SQL Server 2012 Data Quality Services Term based Relation’s in action!
- See what went into building WATSON, an advanced machine learning & natural language processing system powered by Big Data!
- Seven Interesting Google Projects that a Data Professional may not have heard about:
- How to clean data using Regular Expressions in Data Quality Services?
- How to clean address records using third-party reference data-sets in Data Quality Services?
- Difference between Term based relations and Domain values in SQL server 2012 Data Quality Services
- There’s been a growing interest in Hadoop & Big Data, Here’s the Proof:
- How to detect unrealistic or invalid values using Data Quality Services?
- How to standardize data using Data Quality Services?
- Join #SQLPASS virtual chapters for free online #SQLServer learning!
- Azure PASS VC Next meeting: Kung Fu Migration to Windows Azure SQL Database
- How to import data from Excel file to SQL Server:
- Master Data Services: Analogy to remember what are Models, Entities and Attributes
- Two ideas to make your social network activities “Searchable”:
- Guest Blog: How we use Fuzzy Lookup add-in in our company to solve data inconsistency problems:
- How to clean similar textual data in Excel via Fuzzy lookup add-in?
- Microsoft StreamInsight: “The type or namespace name ComplexEventProcessing does not exist in the namespace Microsoft”
- I played with Twitter Firehose for couple of hours and how you can do so too:
- Back to basics: What’s CRUD?
- Data Quality Servies: What does a locked Knowledge Base indicate?
- How I installed StreamInsight 2.0 on my demo machine:
- Windows 7: How do you stop programs from automatically running when Windows Starts?
- Grab Twitter search data using R and export to a tab delimited file
- Where’s the Formula Bar in Excel 2013?
- Three V’s of Big Data with Example:
- Hadoop on Azure’s Javascript Interactive Console has basic graphing functions:
- Mapping “Facebook Page Likes vs Country” using PowerView in Office 2013
- Book Review: The Data Journalism Handbook
- How to Load Twitter data into Hadoop on Azure cluster and then analyze it via Hive add-in for excel?
- Visualizing MapReduce Algorithm with WordCount Example:
- Five examples of Recommendation Systems on the web:
- Let’s Install R & RStudio on Windows Machine!
- A Social Media Analytics Sample Dashboard in Excel Powered by PowerPivot.
- Things I shared on Social Media Networks during Oct 19 – Nov 11
- what are the end – to – end processes for developers to build out a Master Data Services 2012 solution?
- Resource: Learn to build an Enterprise Information Management system using Data Quality Services, Master Data Services and SQL Server Integration Services
- How to Solve: SQL Server 2012 Data Quality Services Does not allow you to export the cleansing or matching results to an Excel file if you are using 64-bit version of Excel
- SQL Server Data Quality Services: How to test Domain Rules in the DQS client.
- End to End Demo: Hadoop (HDInsight) + Hive + Excel + Power View + Azure Data Market
- Where’s my SQL Server Master Data Manager Web UI?
- Data Mining Demo for Marketing vertical: How to create a Targeted mailing list?
- How to Solve: Excel Data Mining add-in disappeared.
- Getting started with HDInsight (a.k.a Microsoft’s Big Data hadoop Platform) on local Windows Machine!
- Five quick reasons why I use virtual machines on my personal computer:
- PerformancePoint services: changing the Title and Logo in the Dashboard
- Error in Importing KPI’s to Performance Point 2010 Dashboard designer from SQL Server 2012 Analysis Services MultiDimensional cube
- PowerPivot: Quick Tip regarding Copy-Pasting Tables in PowerPivot 2010
- Crunch more than 1 million rows in Excel 2010 with free addin called Power Pivot!
- SQL Azure: Is there a “per transaction” cost for Windows Azue SQL Database?
- Things I shared on Social Media Networks during Oct 11 – Oct 18
- “An unexpected system error occured…” – While trying to establish a Data Connection in Performance Point 2010 Dashboard Designer
- How to Delete a Knowledge Base in SQL Server 2012 Data Quality Services?
- How I think of what is KnowledgeBase in SQL Server 2012 Data Quality Services
- Things I shared on Social Media Networks during Oct 3 – Oct 10
- Five things I like about RescueTime:
- Access Fundamentals: What are Tables, Queries, Reports & Forms?
- Microsoft Business Intelligence: Power View can be Exported to PowerPoint (PPT)!
- For my Archives: Few questions answered on Windows Azure & SQL Azure MSDN forums
- Steps I followed to Install SQL Server 2012 Master Data Services (MDS) on my Demo Machine:
- Why would I not bother “REFRESHing” my Desktop ever again..
- Completed 225 posts! + It’s my Birthday today!
- New Journal Article Published – Title: “Building an Ideal Tabular Model for Power View reports”
- Productivity Tip: Convert “Emails” TO “Tasks” or “Prioritized To-DO List” in Outlook 2010
- Azure PASS VC session on 24th Sep 2012 Monday: Getting Started with Windows Azure
- About My First Professional Experience that Introduced me to the amazing world of Databases!
- How to Create Calendar Files (.ics) that can be Shared/Emailed/Downloaded?
- One Insight from Analyzing my Past Year’s Blog Traffic Data:
- Machine Learning VS. Data Mining
- Excel data Mining in Action: Forecasting Twitter Followers for next week
- [video] Data Science is not NEW – it’s just that we live in a VERY special time!
- How to add External Links to Facebook Page Tabs?
- Excel: How to split the content of one excel cell into separate columns?
- How to enable Data Mining in EXCEL powered by SQL Server Analysis Services?
- World has changed: from “what’s NEW” to “what does it all Mean”
- Productivity Tip: Assign Keyboard Shortcut to open a program (in windows 7)
- Video: 5 things learned in 30 months of blogging by Paras Doshi @ Dallas WordPress user group.
- Data Visualization: Think India had a poor 2012 olympics? Think again..
- Visualizing dataset of 2 million+ passwords:
- Mapping Business Intelligence Developer’s Tools: Microsoft SQL server & SAP Netweaver BW
- A nice Data Visualization on User’s Twitter “Text Data”:
- Social Media Analytics. Facebook Page Smackdown: Status updates vs Images?
- What Chart should I use for effective graphical representation of data?
- SharePoint PowerPivot Site: How to extend document library to connect to Tabular Model for some Power View magic!
- Where can we find datasets that we can play with for Business Intelligence, Data Mining, Data Analysis Projects?
- SQL Azure’s Journey from Inception in Year 2008 to June 2012!
- PowerPivot Model: How to TEST or EDIT existing connections?
- PowerPivot Model: Why am I not seeing “Month Names” in correct logical order?
- Back to basics: What is the difference between Data Analysis and Data Mining?
- Data Mining: Classification VS Clustering (cluster analysis)
- How to Solve Error: After Reboot, SharePoint sites says “Service Unavailable”
- Visualize FourSquare Checkins on Google Maps:
- What’s the benefit of columnar databases?
- Who on earth is creating “Big data”?
- Passed couple of SQL Server 2012 Business Intelligence Beta Exams!
- Quote for Big-Data / Data-Science/ Data-Analysis enthusiasts:
- Visualizing what Merge Transformation in SQL server Integration Services (SSIS) does:
- News – Now a Certified Cloud Guy – Completed University of Washington’s cloud certifcate requirements!
- SolidQ Journal: Building Ideal PowerPivot Model for Power View reports
- Top Five reasons to contribute on MSDN or StackOverflow forums
- How to Disable password expiration for Windows Server 2008 R2 (domain controller)?
- Addressing few Q’s a reader had about Google’s BigData offering BigQuery:
- This is cool: Microsoft project codename “Social Analytics”
- First Impression: Google’s BigData offering called BigQuery
- Professional Development Resource: Pinal Dave’s Series on Developer Training
- we now have 3 (three) options to run SQL server on CLOUD.
- New Azure portal is ALL HTML 5!
- Quick updates from meet windows azure event for Data Professionals
- Get started on Windows Azure: Attend “Meet Windows Azure” event Online
- Want to learn about BigData? read Oreilly’s Book “Planning for BigData”
- Examples to help clarify what’s unstructured data and what’s structured?
- Played with Microsoft research “Project Daytona” – MapReduce on Windows Azure
- One more way to run SQL Server on cloud: SQL server on AWS RDS
- How do you reduce the network “latency” between application and SQL Azure?
- Business operation challenges faced by SaaS provider & cloud provider
- Visualizing search engine terms (words) via Word cloud a.k.a word frequency visualization tool
- what’s the role of a “Master” database in a SQL Azure world?
- Change Live ID associated with Azure Service Administrator
- Excel file does not open, Its stuck indefinitely in “opening in protected view” stage
- Did you knew: You can change the Location of “Desktop” folder
- Manage ALL relationship’s between tables while building PowerPivot Model
- Bird’s Eye view of SharePoint BI Dev Environment Setup process (SQL Server 2012, Sharepoint 2010)
- How to disable the password expiration policy in Windows Server 2008 R2 (Demo Machine) ?
- Half way through Toastmaster’s competent communicator manual, it’s one of my career goal.
- Getting started with creating Java app on Google App engine – Guest Post by Dhwaneet Bhatt
- Reports hosted on SQL Azure reporting (preview) accessed via Windows Phone, iPhone and Android phones!
- How to add a column in an imported Table while developing SQL Server 2012 Analysis services Tabular Model
- Worried about Securing SQL Azure Data? SQL Azure and “Trust Services” could help.
- SQL Azure Beginner’s TSQL Task: Create a Database via TSQL command
- SQL Azure Beginner’s TSQL Task: Creating a basic stored procedure
- Want to practice public speaking? Join Toastmaster’s!
- How I solved sharepoint’s service unavailable error, HTTP 503?
- Ability to create Hans-Rosling styled BI dashboard with PowerView is great!
- What’s the widely accepted definition of cloud computing?
- A nice slidedeck on SQL Azure reporting: #SQLPASS Business Intelligence Virtual Chapter Slides and References by Simran Jindal
- Gartner’s Hype cycle for CLOUD COMPUTING: 2008 – 2009 – 2010 – 2011
- Great to see neck to neck price competition between Azure and AWS
- Do tables in a SQL Azure Database need to have a primary key?
- Book review: Linchpin by Seth Godin
- Guest post on SQL Authority
- Meet the NEW ivy’s of our world: Coursera, db-class, saas-class, Khan academy, MITx, TED etc etc
- Five things I learned about “Art of report designing” from Facebook insights.
- [video] The day it all began for SQL Azure
- Graphical representation of the new pricing model of SQL Azure:
- [Video] I am 22 years old, So is SQL server! check out, history of SQL server:
- SQL Azure got a new pricing model!
- Cloud Models (IaaS, PaaS, SaaS) explained with examples
- What is Serialization? May be Star Trek analogy could help..
- Review your SQL Azure security issues and Attack surface, Check out “SQL Azure security services”
- SQL server 2012 introduces a straightforward way to migrate to SQL Azure (via SSMS)
- 10 Beginner Level Windows Azure Interview Question and Answers (Q&A)
- Understanding Cloud Computing Modalities Analogically…If my Laptop were a Cloud…
- SQL Azure: Indexes are very helpful but they cost $Money$
- [WordPress.com Tip] How to add author information for your content being searched via Google
- [cloud 101] Is cloud secure?
- Cloud University – A nice resource to help you develop understanding of key elements of cloud computing
- How to enable RDP (Remote Desktop) for a Windows Azure Web Role?
- A shout-out to top commenters in 2011:
- Step by Step guide to Import a bacpac to SQL Azure Database via Import and Export CTP
- Step by Step guide to Export a SQL Azure Database to Azure storage via Import and Export CTP
- How to make the best use of your SQL Azure Free Trial?
- Summary of Just Learned Tips that i have submitted for year 2011 at BeyondRelational.com site
- Thank you for the Gift: Windows Phone and Klout!
- Part 10/10 of “Getting started with SQL Azure” series is live!
- Uploading a Hello world python app on Google App Engine (with windows as your local OS)
- Upload a file to windows azure blob via “data transfer” tool
- Upload CSV and excel files to SQL Azure via “Data Transfer” tool
- part 9 of “Getting started with SQL Azure” series is live!
- part 8 of “Getting started with SQL Azure” series is live!
- part 7 of “Getting started with SQL Azure” series is live!
- Book Review: SQL server Interview Questions and Answers by Pinal Dave and Vinod Kumar.
- part 6 of “Getting started with SQL Azure” is live!
- [Link] 2011 Testing latency between client and SQL Azure via client statistics in SSMS
- yay! I passed Exam 70 583 PRO: Designing and Developing Windows Azure Applications
- Forum Q&A: Best method to Migrate on premise to SQL Azure
- Forum Q & A: Question regarding TimeStamps in SQL Azure
- Prepare yourselves for ‘Capped Data Plans’ VS ‘growing cloud computing adoption’ battle.
- Forum Q&A: Is SQL azure and SQL Server the same?
- How to create users with limited access in SQL Azure?
- How to rename a SQL Azure database?
- In cloud computing, Scalability is not equal to Elasticity and Vice Versa.
- Quick summary of Ideas that I have logged at My Great Windows Azure Idea site
- part 5 of “Getting started with SQL Azure” is live!
- I gave back at Dallas GiveCamp – And why I think every software professional should consider doing so too!
- SQLPASS 2011 was amazing!
- Part 4 of “Getting started with SQL Azure” is live!
- Joining University of Washington’s certificate in cloud computing program!
- Part 3 of “Getting started with SQL Azure” is live!
- SQLServer Quiz 2011 – Which are the options available to a DBA to tune a SQL Azure database?
- It’s my birthday! And hey – it’s the 100th post!
- Has “Cloud Computing” replaced “Distributed computing”?
- How to avoid Men in Middle attack when you try establishing a new connection to SQL Azure via SSMS
- [Link] Tuning SQL Azure Databases
- My article on “Tuning SQL Azure databases – Part 2/2” got published in SolidQ Journal’s september edition
- Part 2 of “Getting started with SQL Azure” is live!
- my “Migrating Access Database to SQL Azure database using SSMA” on SolidQ blog is live!
- How to import data from Azure Datamarket to Excel
- Part 1 of the “Getting started with SQL Azure” is live!
- What are common mistakes that new or inexperienced managers make?
- [SSIS] unzip a file in SQL server Integration services (SSIS) package
- Audio Interview’s of Interesting folks passionate about cloud computing on cloudplumbing.com
- Seven software delivery models and why software as a service (SaaS) is the future!
- Got Microsoft community contributor award
- Summary – SQL server to SQL Azure migration
- Got the Microsoft student partner graduation certificate!
- Migrating Data from SQL server to SQL Azure using BCP
- Never let your Domain name Expire. Never!
- Presented on “What Mobile Device(s) Plus cloud computing mean for the real world” at Ignite Ahmedabad
- Introduction to SQL Azure reporting
- [Link] Amazing list of SQL Azure Articles on gainingaccess.net managed by Patrick wood >> Check it out
- SQL Azure VS Azure Table storage
- SQL Azure Interview Questions and Answers
- Thanks Dhananjay Kumar for introducing me to Word 2010 Smart Art!
- Few snapshots
- why I liked reading “One Minute Manager”?
- weekly channel 9’s “cloud cover show” to stay updated on windows Azure!
- Diagrammatic representation of “SQL Azure VS SQL server”
- Hosting a Static Website in Windows Azure Blobs
- Top two ways you can screw up the established SQL Azure connection from SSMS 2008 R2 running locally
- An article about Windows Azure Data Market and open government data initiative
- Migrating Data from SQL server to SQL Azure using SSIS
- SQL Azure July 2011 service update has been announced!
- it’s story time!
- A MSDN subscriber get’s an alert message if the Windows Azure platform usage exceeds the base (not chargeable) consumption
- SQL Azure Provisioning model
- Now a two star member of MSDN Windows Azure Platform Forums
- Creating Co-administrator’s for managing SQL Azure databases and servers through Azure management portal
- My article on “Tuning SQL Azure database – Part 1” got published in SolidQ Journal (July 2011)
- How to send an Email from an Azure application
- step by step guide to use import and export features in the Microsoft SQL Server “Denali” Data-tier Application Framework v2.0 Feature Pack CTP to import and export data with SQL Azure
- Cloud Computing is AWESOME :: Defining Cloud Computing the Urban Dictionary style!
- Adding / Deleting / Updating the SQL Azure firewall rules via SSMS
- My Experiments with “Enzo backup for SQL Azure (Beta)” – an one of it’s kind Tool for SQL Azure Backup’s
- Migrating SQL server database schema to SQL Azure database using Generate scripts wizard
- SQL Azure Backup to Windows Azure blobs using Azure management cmdlet (Powershell)
- Blogged a Follow up post on the series ‘Hosting a static website in windows Azure blobs’
- I just logged an Idea on My Great Windows Azure Idea:
- How to edit the content type / Mime type of a windows azure blob content?
- Hosting a static website in Windows Azure blobs
- Met revered APJ Abdul Kalam (Ex President, India) at an event organized by Times Foundation
- Get an Azure account without submitting credit card details (Valid for 30 days) – PROMO EXPIRED!
- want to learn SQL Azure – here is an “Introduction to SQL Azure” tutorial (FREE!)
- SolidQ Journal Article : “Migrating Data into Microsoft’s Data Platform – SQL Azure”
- Automating SQL Azure backup to On premise Disks using a SQL Azure management cmdlet
- Quick List of “Databases in the cloud”
- programmatically verifying that the underlying database is SQL Azure
- Extending SQL Azure with Azure worker roles
- sys.dm_db_partition_stats : A SQL Azure Dynamic management view (DMV) to calculate database size
- Explore the features being added with each release of SQL Azure on “What’s New in” Site for SQL Azure
- A step by step guide to Install Adventure works LT ( sample database ) on SQL Azure
- How to configure SQL Azure firewall from Azure management portal
- I just logged an idea on mygreatsqlazureidea.com
- Step by step guide to import data from SQL Azure to PowerPivot
- Two reasons why a Data Technologist should avoid ‘select * ………’ with SQL Azure
- Multiple servers per subscription – now available with SQL Azure may 2011 release.
- Interesting questions on SQL Azure collected from a USER profile (MS TECH TALK) on MSDN SQL Azure Forum
- Attended Azure Boot Camp at Ahmedabad on 30th april 2011
- Won an award for my project: ‘Technical considerations with SQL Azure’!
- copy SQL Azure databases programmatically using ‘As copy of’ TSQL command
- View SQL Azure bills through SQL Azure Database view’s: ‘sys.database_usage’ and ‘sys.bandwidth_usage
- Did you knew: SQL Azure keeps three replicas of your database!
- Migrating SQL server 2005/2008 database to SQL Azure using SQL Azure migration wizard
- Bill Gates and Steve jobs together (Not unreal!) discussing on Future of Technology.
- [SQL server Database] Keeping track of ‘what,how,who’ of changed data in SQL server 2008
- Video: Did you know?
- “Times have changed. We now have a new breed of leaders called – affectionate leaders” – R Gopalakrishnan
- TED Video: Visualizing the medical data explosion by Anders Ynnerman
- Microsoft Community Tech Days [Ahmedabad 2010]
- Ted video: The web secret stories by jonathan harris
- Book review: Getting Real by 37signals
- Hans Rosling’s Ted videos
- [Fiction] Letter from a Geek who lived in the unglorious era of ’99 !
- [Quote]
- How to Include Charts in Visual Studio 2008 Express Edition using Microsoft chart controls
- Book review : If god was a banker by ravi subramaniam
- I stumbled upon a video on youtube. the title is ‘is information management just another hype?’. it’s a paradigm shifter!
- Ted Video: The shape shifting future of mobile phone by Fabian Hemmert AND videos on similar innovative Human Computer Interaction concepts
- Dr APJ Abdul kalam at Yuva Unstoppable’s [NGO] fifth Anniversary was truly inspirational!
- Ted Video: The beauty of data visualization by David McCandles
- Ted Video: How social media can make history by clay shirky
- Ted Video: A monkey economy as irrational as ours by Laurie Santos
- Video: Steve Jobs on How to live before you die
- Book Review : Shantaram by Gregory David Roberts.
- Creativity – what is that?
- India can win 50 gold medals at olympics!
- Book Review : Funda of Mixology – ” what bartending teaches that IIM doesn’t..” by maniak dhar
- Chandrayaan Budget : 400 crores!! can India afford a Moon Mission?
Like this:
Like Loading...